You can create a master detail report using the Table control and grouping. The following walkthrough takes you through the step by step procedure of creating a Master Detail report.

The walkthrough is split into the following activities:

Adding an ActiveReport to a Visual Studio project
Connecting the report to a data source
Adding a dataset to the report
Adding controls to the report to contain data
Viewing the report

Note:

This walkthrough uses the Customer table from the Reels database. By default, in ActiveReports, the Reels.mdb file is located in the [User Documents folder]\GrapeCity Samples\ActiveReports 9\Data folder.
Although this walkthrough uses Page reports, but this can be implemented using RDL reports also.

When you complete this walkthrough you get a layout that looks similar to the following at design time and at runtime.

Design Time Layout

Runtime Layout

To add an ActiveReport to the Visual Studio project

To connect the report to a data source

To add a dataset

SQL Query	Copy Code
SELECT CustomerID, Title, LastName, Quantity, Price, [Quantity]*[Price] AS Total FROM CustomerOrders WHERE CustomerID < 1010

To create a layout for the report

To add a table with grouping to the report

To add a fourth column to the table

To add data to the table

Place your mouse over the Textbox located in the first column of the group header row of the table to display the field selection adorner.
Click the adorner to display the list of available fields from the DataSet and select LastName. This automatically places an expression in the group header row and simultaneously places a static label in the table header row.
In the Properties window, set the FontSize property of this textbox to 12pt.
In the table header row, delete the static label Last Name.
To display static labels at the beginning of each new group, right-click the row handle to the left of the group header row and select Insert Row Below.
In the first column of the detail row, use the field selector adorner to select the Title field.
In the textbox immediately above it, type Title.
In the table header row, delete the static label Title.
In the second column of the detail row, use the field selector adorner to select the Quantity field. This automatically places an expression in the detail row and simultaneously places a static label in the header row of the same column.
In the Properties window, set the TextAlign property of the Quantity field to Left.
Cut the static label and paste it into the inserted row immediately above the detail row.
In the third column of the detail row, use the field selector adorner to select the Price field.

In the Properties window, set the following properties.

Property Name	Property Value
TextAlign	Left
Format	C (uses currency formatting)

Cut the static label from the group header and paste it into the inserted row immediately above the detail row.
Select the Total field for the fourth column of the detail row of the table.

In the Properties window, set the following properties.

Property Name	Property Value
TextAlign	Left
Format	C (uses currency formatting)

Cut the static label from the group header and paste it into the inserted row immediately above the detail row.

To refine the look of the report

Right-click any row handle to the left of the table and select Table Header to remove the table header row since it is not being used.
Select the Header row containing the labels by clicking the table handle to the left of the row.

In the Properties window, set the following properties.

Property Name	Property Value
RepeatOnNewPage	True
FontWeight	Bold

From the Report Explorer, drag the Total field into the group footer row in the fourth column to add subtotaling to the group. Notice that the expression automatically uses the Sum function.

Go to the Properties window to set the following properties.

Property Name	Property Value
Format	C (uses currency formatting)
FontWeight	Bold

From the Report Explorer, drag the Total field into the table footer row in the fourth column. This adds grand totaling to the table.

Go to the Properties window to set the following properties.

Property Name	Property Value
Format	C (uses currency formatting)
FontWeight	Bold

Delete the static label Total from the top row.

Click the gray area below the design surface to give report the focus and from the Report menu, select Page Header.

Note: Page reports do not have page header and page footer options. Go to the last step of this section to finish your page report.

From the toolbox, drag the TextBox control onto the PageHeader section to span the entire width of the report.

Go to the Properties Window to set the following properties.

Property Name	Property Value
TextAlign	Center
FontSize	14pt
Value	Customer Orders

For an page report, in the Report Explorer select the Table data region and set its FixedSize property to 6.5in, 7in.

To view the report

Concepts

Grouping Data (Page Layout)